﻿using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UnityCore2;

namespace UnityNeuroEngineConsole
{
    public partial class Form1 : Form
    {
        
        public Form1()
        {
            InitializeComponent();
            UnityToken tok = new UnityToken("INSERT 1 \"SELECT * FROM tblprofiles\"");
            string dat = UnityCore2.StdLib.FnRawData.PutDelimiter('|', true, "Tristan", "Victor", "Nelson", "Ray", "Arnel");
            string[] dats = UnityCore2.StdLib.FnRawData.RemDelimiter('|', true, dat);
            UnityBuffer ub = new UnityBuffer();
            ub.AddTable("Tristan", 
                new string[] { "fID", "fName", "fAddress", "fStamp" }, 
                new Type[] { typeof(int), typeof(string), typeof(string), typeof(DateTime) });
            ub.AddTable("Tristan",
                new string[] { "fID", "fName", "fAddress", "fStamp" },
                new Type[] { typeof(int), typeof(string), typeof(string), typeof(DateTime) });
            ub.AddTable("Tristan",
                new string[] { "fID", "fName", "fAddress", "fStamp" },
                new Type[] { typeof(int), typeof(string), typeof(string), typeof(DateTime) });

            ub.Command("GLOBAL \"SELECT * FROM tblprofile\"");
            ub.Command("0 \"INSERT INTO tblprofile(fName, fAddress) VALUES ('Tristan', 'La Trinidad')\"");
        }
        
    }
}
